Posted to microsoft.public.excel.worksheet.functions
|
|
sum of cells in different rows & columns & criteria
Thanks, I was able to put both replys to use.
"T. Valko" wrote:
Try this:
=SUMIF($B2:$F3,G1,$A2:$E3)
Copy across
--
Biff
Microsoft Excel MVP
"Max" wrote in message
...
Errata, missed cols E n F earlier. Line:
In G3: =SUMIF($B:$B,G1,$A:$A)+SUMIF($D:$D,G1,$C:$C)
should read:
In G3:
=SUMIF($B:$B,G1,$A:$A)+SUMIF($D:$D,G1,$C:$C)+SUMIF ($F:$F,G1,$E:$E)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
|